Boost SQL Server Database Performance with In-Memory OLTP

This lecture, is an overview of what you will learn in this section.

In this lecture, you will learn about the requirements for enabling In-Memory OLTP in SQL Server.

In this lecture and demo, you will see a simple example, of you can create an In-Memory OLTP-enabled database in SQL Server. This database, will be used for all our live demonstrations.

In this lecture, you will learn about the T-SQL constructs not supported by In-Memory OLTP in SQL Server.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this lecture, you will learn what Memory-Optimized Tables are in SQL Server, as well as about their two types: durable and non-durable.

In this lecture and demo, we will create together a non-durable memory-optimized table.

In this lecture and demo, we will create together a durable memory-optimized table.

In this lecture and demo, we will compare the performance between disk-based and memory-optimized tables for a simple data insert scenario, via a simple example.

In this lecture, we'll be discussing about choosing Hash or Nonclustered Indexes. We will use a concrete example to understand the decision, work through the reasoning, and finish with a short knowledge check.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this lecture, you will learn what are natively-compiled stored procedures in SQL Server.

In this demo, you will learn how to create natively-compiled stored procedures in SQL Server.

In this lecture and demo, we will compare the performance between disk-based and memory-optimized tables, with natively-compiled stored procedures for the data insert scenario, via a simple example.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this lecture, we will discuss about the process of migrating a SQL Server database to In-Memory OLTP.

In this lecture, we will discuss if your workload will execute faster, using SQL Server In-Memory OLTP.

In this lecture and demo, we will discuss about the available methods, of estimating if your workload’s performance can benefit from In-Memory OLTP.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this lecture and demo, we will talk about the Test environment used for the course’s live demonstrations and examples.

In this lecture and demo, we will import a sample text file of 100.000 records, thus simulating a basic ETL process using In-Memory OLTP and compare performance between disk-based execution and memory-optimized tables.

In this lecture and demo, we will update a single column in a table with 100.000 records using In-Memory OLTP and compare performance between disk-based execution and the executions using memory-optimized tables and natively-compiled stored procedures.

In the lecture and demo, we will run an aggregation against a table with 100K records using In-Memory OLTP and compare performance between disk-based execution and the executions using memory-optimized tables and natively-compiled stored procedures.

This lecture, is a recap of what you have learned in this section.

This lecture, is an overview of what you will learn in this section.

In this special topic, I answer different common questions people have, about SQL Server In-Memory OLTP.

In this lecture, we'll be discussing about the transaction isolation levels supported by SQL Server In-Memory OLTP.

In this lecture, we'll be discussing about how SQL Server In-Memory OLTP can be used for reducing the I/O bottlenecks, that can slow down reporting queries and thus increase overall performance.

In this special topic, we  delve into the core concepts and practical steps necessary for efficiently managing large volumes of data using In-Memory OLTP.

In this special topic, we’ll explore how In-Memory OLTP fits into cloud environments like Azure and AWS, and how we can leverage its power to boost database performance while managing the constraints of cloud resources.

In this lecture, we’ll explore common mistakes that occur when implementing SQL Server In-Memory OLTP. These aren’t theoretical issues—they’re drawn from real-world experience. Avoiding these will help you build faster, more stable, and scalable systems.

In this session, we’ll walk through how to properly size and plan capacity for your In-Memory OLTP solution in SQL Server.

In this session, we’ll walk through the differences between SCHEMA_ONLY and SCHEMA_AND_DATA, when to use each, and how this choice impacts performance, logging, and recovery.

In this lecture, we’ll go over best practices for benchmarking memory-optimized workloads—what to measure, how to compare fairly, and how to avoid common pitfalls.

This lecture, is a recap on what you have learned in this course.

Bonus Lecture.